| 翻訳と辞書 |
| Staging (data) ： ウィキペディア英語版 |
Staging (data)
A staging area, or landing zone, is an intermediate storage area used for data processing during the extract, transform and load (ETL) process. The data staging area sits between the data source(s) and the data target(s), which are often data warehouses, data marts, or other data repositories.〔(Oracle 9i Data Warehousing Guide, ''Data Warehousing Concepts'' ), Oracle Corp.〕
Data staging areas are often transient in nature, with their contents being erased prior to running an ETL process or immediately following successful completion of an ETL process. There are staging area architectures, however, which are designed to hold data for extended periods of time for archival or troubleshooting purposes.
==Implementation==
Staging areas can be implemented in the form of tables in relational databases, text-based flat files (or XML files) stored in file systems or proprietary formatted binary files stored in file systems.〔Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals, p. 137-138, Paulraj Ponniah, 2001.〕 Staging area architectures range in complexity from a set of simple relational tables in a target database to self-contained database instances or file systems.〔(''BI Experts: Big Data and Your Data Warehouse's Data Staging Area'' ), The Data Warehousing Institute, Phillip Russom, 2012.〕 Though the source systems and target systems supported by ETL processes are often relational databases, the staging areas that sit between data sources and targets need not also be relational databases.〔(Is Data Staging Relational? ), Ralph Kimball, 1998.〕
抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』
■ウィキペディアで「Staging (data)」の詳細全文を読む
スポンサード リンク
| 翻訳と辞書 : 翻訳のためのインターネットリソース |
Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.
|
|